﻿CREATE PROCEDURE [dbo].[proc_AppMenu_GetItem]
	(
		@MenuId int
	)
AS
	Select 
	MenuId,
	ParentId,
	Title,
	CId,
	AId,
	isnull((Select Title From AppController Where Id=AppMenu.CId),'h') As ControllerName,
	isnull((Select Title From AppAction Where Id=AppMenu.AId),'h') As ActionName,
	CreateTime,
	Sort
	From AppMenu Where MenuId=@MenuId
	RETURN
